package cn.gson.boot.model.dao;

import cn.gson.boot.model.pojos.AttributeValue;
import cn.gson.boot.model.pojos.Shenhe;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import javax.transaction.Transactional;

public interface ShenHeDao extends CrudRepository<Shenhe,Integer> {
    //删除审核（物理删除）
    @Transactional
    @Modifying(clearAutomatically = true)
    @Query(nativeQuery = true,value = "delete from shenhe where sh_tabid=?1 and sh_shouming=?2")
    public void delectShenHe(Integer tabId,String shuoMing);

}
